INSERT INTO upms2.[dbo].[tuser](id,password,username)VALUES('3','123456','guest');
INSERT INTO upms2.[dbo].[tuser](id,password,username)VALUES('2','123456','user');
INSERT INTO upms2.[dbo].[tuser](id,password,username)VALUES('1','123456','admin');

-- 自定义MD5加密
update   upms2.dbo.tuser set password='e10adc3949ba59abbe56e057f20f883e'

	insert into upms2.dbo.trole(id,name) values('1','ROLE_ADMIN')
	insert into upms2.dbo.trole(id,name) values('2','ROLE_USER_VIEW')
	insert into upms2.dbo.trole(id,name) values('3','ROLE_USER_EDIT')
	insert into upms2.dbo.trole(id,name) values('4','ROLE_USER_DEL')
		insert into upms2.dbo.trole(id,name) values('5','ROLE_USER_ADD')


	INSERT INTO UPMS2.DBO.tuser_trole (tuser_id,trole_id) VALUES('4','1');

	INSERT INTO UPMS2.DBO.tuser_trole (tuser_id,trole_id) VALUES('2','2');
	INSERT INTO UPMS2.DBO.tuser_trole (tuser_id,trole_id) VALUES('2','3');
	INSERT INTO UPMS2.DBO.tuser_trole (tuser_id,trole_id) VALUES('2','4');

	INSERT INTO UPMS2.DBO.tuser_trole (tuser_id,trole_id) VALUES('3','2');
INSERT INTO upms2.DBO.tuser_trole (tuser_id,trole_id) VALUES('2','5');

-- 修改trole表增加别名
update upms2.dbo.trole set alias='UPMS所有权限' where id='1'

update upms2.dbo.trole set alias='用户浏览权限' where id='2'

update upms2.dbo.trole set alias='用户编辑权限' where id='3'

update upms2.dbo.trole set alias='用户删除权限' where id='4'

update upms2.dbo.trole set alias='角色添加权限' where id='5'